Blender

Entity Definition

Logical Name : Blender
Physical Name : CO_BLD

A connection between a LOGICAL NOZZLE and one or more LOCATIONs each containing a single BULK ITEM which are blended by the LOGICAL NOZZLE when performing a FUELLING TRANSACTION

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
RetailStoreID (FK) A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter ID_STR_RTL Identity integer StockMeter(AS_MTR_STK)
RetailStoreID (FK)(PK) A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter ID_STR_RTL Identity integer Nozzle(AS_NZL)
FuelingPointID (FK)(PK) A unique identifier for the FuelingPoint at a particular retail store ID_PNT_FUEL Identity integer Nozzle(AS_NZL)
NozzleID (FK)(PK) A unique identifier for the Nozzle ID_NZL Identity integer Nozzle(AS_NZL)
LocationID (FK)(PK) A unique system assigned identifier for the Location. ID_LCN Identity integer InventoryLocation(LO_LCN_INV)
StockMeterID (FK) A unique identifier for the stock meter ID_MTR_STK Identity integer StockMeter(AS_MTR_STK)
BlendPercentage The percentage of the final blend that the given BULK ITEM constitutes. PE_BLD Percent decimal(7,4)

Relationships

Parent Entity Verb Phrase Child Entity
Nozzle is connected to Blender
InventoryLocation stores fuel for Blender
StockMeter records Blender

Logical Views containing Blender

Logical View
Logical 20000 - Forecourt Macro View
Logical 20010 - Forecourt Fueling Point View
Logical 20040 - Forecourt History View
Logical 20050 - Forecourt Tank Gauge View